<html>

<head>
<?php include("../../MerchandiseBay/conn.php"); ?>
<?

$sqlReservation="select * from reservation order by reservationdate desc";
$qryReservation=mysql_query($sqlReservation,$conn);
?>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<script language="javascript" type="text/javascript">

var win=null;
function NewWindow(mypage,myname,w,h,scroll,pos){
if(pos=="random"){LeftPosition=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;TopPosition=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
else if((pos!="center" && pos!="random") || pos==null){LeftPosition=0;TopPosition=20}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=yes';
win=window.open(mypage,myname,settings);}

</script>
</head>

<body bgcolor="#0099CC">

		
<table border="1" width="676" id="table1">
  <tr> 
    <td height="33" colspan="9"><strong><font size="4" face="Times New Roman, Times, serif" color="#000000">Reservation &nbsp;List </font></strong></td>
  </tr>
  <tr> 
    <td bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana">No.</font></div></td>
	<td width="9%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana"> 
    Name</font></div></td>
    <td width="8%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana"> 
    Tel no</font></div></td>
    <td width="8%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana"> 
    Email</font></div></td>
    <td width="8%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana"> 
    Reservation Date</font></div></td>
    <td width="7%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana">Reservation Time </font></div></td>
    <td width="9%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana">
    Category&nbsp;</font></div></td>
	<td width="7%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana">
    Quantity&nbsp;</font></div></td>
	<td width="6%" bgcolor="#E4E4E4"><div align="center"><font size="1" face="Verdana">
    Code Product&nbsp;</font></div></td>
	
  </tr>
  <?
  $count=1;
  while($rowReservation=mysql_fetch_assoc($qryReservation)) {?>
  <tr> 
    <td width="4%" align="center"><font size="1" face="Verdana"> <?=$count?></font></td>
	<td width="9%" align="center"> <font size="1" face="Verdana"> 
      <?=$rowReservation['name']?></a>
      </font></td>
    <td width="8%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['telno']?>
      </font></td>
    <td width="8%" align="center"><font color="#FFFFFF" size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['email']?>
      </font></td>
    <td width="8%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['reservationdate']?>
      </font></td>
    <td width="7%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['reservationTime']?>
      </font></td>
    <td width="9%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['category']?>
      </font></td>
	   <td width="7%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['quantity']?>
      </font></td>
	 <td width="6%" align="center"><font size="1" face="Verdana">&nbsp; 
      <?=$rowReservation['codeproduct']?>
      </font></td>
	 
  </tr>
   <?
	$count=$count+1;
	}?>
  
</table>
		
</body>

</html>
